Data Dictionary

External Tax Summary Calculation Template

External Tax Summary Calculation Template

OVERVIEWFIELDS

Overview

The import process is designed to bypass the SureTax Calculation Engine and directly ingest pre-aggregated tax data into the Returns Compliance Module. External providers send batch files that are processed via the SureTax Common Batch API. The data is lightly aggregated and stored in the Returns Summary Database for downstream compliance reporting. Traceability is maintained through metadata linking to the external calculation engine. The system supports multiple industry formats with flexible schema definitions:

Download Template: External Tax Summary Calculation Template

File Type: csv

Detail Record

The record below shows the various fields within the record. Each field is linked within the data dictionary which provides additional information including field constraints as well as allowed values.

Display Name	Field Name	Field Type
Source Geocode	SourceGeocode	string
Service Group	ServiceGroup	ServiceGroup
Tax Type Code	TaxTypeCode	TaxTypeCodes
Tax Type	TaxType	int
Tax Cat Code	TaxCatCode	string
Tax Category	TaxCategory	TaxCategory
Auth Level	AuthLevel	string
State	State	string
Country	Country	string
City	City	string
Tax Authority	TaxAuthority	string
Units	Units	decimal
GrossRevenue	Gross Revenue	decimal
Non-Taxable Revenue	Non-TaxableRevenue	decimal
Tax Exempt Revenue	TaxExemptRevenue	decimal
Net Revenue	NetRevenue	decimal
Revenue Base	RevenueBase	decimal
Tax Rate	TaxRate	decimal
Effective Tax Rate	EffectiveTaxRate	decimal
Fee Rate	FeeRate	decimal
Tax	Tax	decimal
Tax On Tax	TaxOnTax	decimal
Total Tax	TotalTax	decimal